{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Absen","New-cara","Cara"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Absen","index":0,"n_rows":28,"n_cols":37,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,5,2,35],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
[]
[]
["No","Section","Emp.No","Name","Designation","2017-03-01"]
[null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Total NPL"]
[]
[{"$f":"+A4+1","v":1},"Safety","00111384","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[{"$f":"+A6+1","v":2},"Safety","00111385","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F7:AJ7,\"NPL\")","v":1}]
[{"$f":"+A7+1","v":3},"Safety","00111386","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[4,"Safety","00111387","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[5,"Safety","00111388","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[6,"Safety","00111389","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[7,"Safety","00111390","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[8,"Safety","00111391","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[9,"Safety","00111392","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[10,"Safety","00111393","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[11,"Safety","00111394","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[12,"Safety","00111395","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[13,"Safety","00111396","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[14,"Safety","00111397","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[15,"Safety","00111398","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[16,"Safety","00111399","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[17,"Safety","00111400","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[18,"Safety","00111401","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[19,"Safety","00111402","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[20,"Safety","00111403","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[21,"Safety","00111404","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[22,"Safety","00111405","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[23,"Safety","00111406","Deni Feri S","Ass SPV",null,null,null,null,null,null,null,null,null,null,"npl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"New-cara","index":1,"n_rows":75,"n_cols":2,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[1,"Pilih data dari A7:AK7 kebawah"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Lalu  pilih conditional formatting>clear rules >clear rules from selected cells"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,"Lalu pilih row 3 >Copy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,"Lalu pilih row dibawahnya( row 4) sampai data paling bawah >lalu paste formatting"]

{"sheet":"Cara","index":2,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Untuk melihat kodenya Klik kanan pada sheet absen >view code"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ganti 5 nya sesuai keinginan"]
[]
[]
[]
[]
[]
["File>option>trust center>trust center settings>macro setting >enable all macro"]